/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_interface_send.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_INTERFACE_SEND
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_interface_send.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_INTERFACE_SEND::CTable_PPM_INTERFACE_SEND( )
 :NPCRecordSet( )
{
  setTableName( "PPM_INTERFACE_SEND" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  SYS_ID.setField( "SYS_ID", DATA_CHAR, 20, 0 );
  makeTableItem( SYS_ID );
  EVENT.setField( "EVENT", DATA_CHAR, 20, 0 );
  makeTableItem( EVENT );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  OBJ_ID.setField( "OBJ_ID", DATA_CHAR, 20, 0 );
  makeTableItem( OBJ_ID );
  OBJ_TYPE.setField( "OBJ_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( OBJ_TYPE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  //SEND_XML.setField( "SEND_XML", DATA_CHAR, 10000, 0 );
	SEND_XML.setField( "SEND_XML", DATA_CLOB, 1024 * 1024 , 0);
  makeTableItem( SEND_XML );
  //ACC_XML.setField( "ACC_XML", DATA_CHAR, 10000, 0 );
	ACC_XML.setField( "ACC_XML", DATA_CLOB, 1024 * 1024 , 0);
  makeTableItem( ACC_XML );
  SEND_TIME.setField( "SEND_TIME", DATA_DOUBLE, 10, 0 );
  makeTableItem( SEND_TIME );
  PROC_ID.setField( "PROC_ID", DATA_CHAR, 20, 0 );
  makeTableItem( PROC_ID );
  SERIAL_NUM.setField( "SERIAL_NUM", DATA_CHAR, 20, 0 );
  makeTableItem( SERIAL_NUM );
}


CTable_PPM_INTERFACE_SEND::CTable_PPM_INTERFACE_SEND( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_INTERFACE_SEND" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  SYS_ID.setField( "SYS_ID", DATA_CHAR, 20, 0 );
  makeTableItem( SYS_ID );
  EVENT.setField( "EVENT", DATA_CHAR, 20, 0 );
  makeTableItem( EVENT );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  OBJ_ID.setField( "OBJ_ID", DATA_CHAR, 20, 0 );
  makeTableItem( OBJ_ID );
  OBJ_TYPE.setField( "OBJ_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( OBJ_TYPE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  MODIFY_DATE.setField( "MODIFY_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( MODIFY_DATE );
  //SEND_XML.setField( "SEND_XML", DATA_CHAR, 10000, 0 );
	SEND_XML.setField( "SEND_XML", DATA_CLOB, 1024 * 1024 , 0);
  makeTableItem( SEND_XML );
  //ACC_XML.setField( "ACC_XML", DATA_CHAR, 10000, 0 );65535
	ACC_XML.setField( "ACC_XML", DATA_CLOB, 1024 * 1024 , 0);
  makeTableItem( ACC_XML );
  SEND_TIME.setField( "SEND_TIME", DATA_DOUBLE, 10, 0 );
  makeTableItem( SEND_TIME );
  PROC_ID.setField( "PROC_ID", DATA_CHAR, 20, 0 );
  makeTableItem( PROC_ID );
  SERIAL_NUM.setField( "SERIAL_NUM", DATA_CHAR, 20, 0 );
  makeTableItem( SERIAL_NUM );
}

CTable_PPM_INTERFACE_SEND::~CTable_PPM_INTERFACE_SEND( )
{
    close();
}

